List by categories
| $chr | [ top ] | ||
| $item->title | |||
| $item->desc | |||
Green Vocabulary: A-to-Z list
[insert_php]
global $wpdb;
for($i=0; $i<26; $i++) {
$chr = chr(ord('A')+$i);
$cnt = $wpdb->get_var(“SELECT count(*) FROM green_voca WHERE `show`=’y’ AND title LIKE ‘$chr%'”);
if($cnt>0) {
print “$chr “;
}
else {
print “$chr “;
}
}
[/insert_php]
List by categories
[insert_php]
for($i=0; $i<26; $i++) {
$chr = chr(ord('A')+$i);
$items = $wpdb->get_results(“SELECT * FROM green_voca WHERE `show`=’y’ AND title LIKE ‘$chr%’ ORDER BY title”);
if(count($items)<=0) continue;
print "
List by categories